#!/bin/sh

echo "Creating default sections"

set -e
set -u

SECTIONS="admin
cli-mono
comm
database
debian-installer
debug
devel
doc
editors
education
electronics
embedded
fonts
games
gnome
gnu-r
gnustep
golang
graphics
hamradio
haskell
httpd
interpreters
introspection
java
javascript
kde
kernel
libdevel
libs
lisp
localization
mail
math
metapackages
misc
net
news
ocaml
oldlibs
otherosfs
perl
php
python
raku
ruby
rust
science
shells
sound
tasks
tex
text
utils
vcs
video
web
x11
xfce
zope"

values=""
for prefix in "" "contrib/" "non-free-firmware/" "non-free/"; do
    for section in ${SECTIONS}; do
        values="${values:+${values},} ('${prefix}${section}')"
    done
done

psql -c "INSERT INTO section (section) VALUES ${values}" >/dev/null
